﻿CREATE TABLE [Queue].[Download]
(
	[DownloadQueueID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [QUEUE_DownloadDownloadQueueID] PRIMARY KEY, 
	[DownloadList] VARBINARY(MAX) NOT NULL CONSTRAINT [QUEUE_DownloadDownloadList] DEFAULT (0), 
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_DownloadCreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [QUEUE_DownloadDateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_DownloadVersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [QUEUE_DownloadVersionDate] DEFAULT GETDATE()
)